Application.yaml

The conf folder will have application.yaml file which consists of application-level properties and data source connection details. The properties should be changed accordingly.

Version Number: The database upgrades to version 12.2.0.0.

Server Port:

The server port# should be unique and unused by any other process in the system.

Server configuration

server:

port: portNumber

Database Details

For Oracle Database, please uncomment the section below by removing the '#' symbols and update the following values according to your environment:

hostname, port, service name, username, password.

Oracle

Oracle Database

#database:

# type: Oracle

# driverClass: oracle.jdbc.driver.OracleDriver

#javax:

# sql:

# DataSource:

# OIPADataSource:

# dataSourceClassName: oracle.jdbc.pool.OracleDataSource

# dataSource:

# URL: jdbc:oracle:thin:@hostname:port:servicename

# user: username

# password: password

MS SQL server

For MSSQL Server Database, please uncomment the section below by removing the '#' symbols and update the following values according to your environment:

MSSQL Server Database

hostname, port, databasename, username, password.

#database:

# type: SQLServer

# driverClass: com.microsoft.sqlserver.jdbc.SQLServerDriver

#javax:

# sql:

# DataSource:

# OIPADataSource:

# dataSourceClassName: com.microsoft.sqlserver.jdbc.SQLServerDataSource

# dataSource:

# URL: jdbc:sqlserver://hostname:port;databasename=databaseName;encrypt=false;trustServerCertificate=true

# user: username

# password: password

DB2 Database

For DB2 Database, please uncomment the section below by removing the '#' symbols and update the following values according to your environment:

hostname, port, databaseName, currentSchema, user, password, portNumber.

Schema name needs to be added to the Db2 Function path. Execute the below to get the current path and add the schema name to it.

Get Current Function Path

SELECT CURRENT_PATH FROM SYSIBM.SYSDUMMY1;

-- Below is the sample output

"SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","username"

--Add currentSchemaName to the above current function path as following.

currentFunctionPath=SYSIBM,SYSFUN,SYSPROC,SYSIBMADM,SYSHADOOP,username,currentSchemaName;

DB2 database

#database:

# type: DB2

# driverClass: com.ibm.db2.jcc.DB2Driver

# URL: jdbc:db2://hostname:port/databaseName:currentSchema=currentSchemaName;currentFunctionPath=SYSIBM,SYSFUN,SYSPROC,SYSIBMADM,SYSHADOOP,username,currentSchemaName;

#javax:

# sql:

# DataSource:

# OIPADataSource:

# dataSourceClassName: com.ibm.db2.jcc.DB2SimpleDataSource

# dataSource:

# user: username

# password: password

# databaseName: databaseName

# serverName: hostName

# portNumber: portNumber

# currentSchema: currentSchema

# driverType: 4

# progressiveStreaming: 2

Security Configuration:

Upgradeutility supports basic authentication. The username and clear/encrypted password will be configured in application.yaml file.

How to generate the encrypted password

Navigate to the upgradeutility folder and provide the values for "masterPassword and secretToEncrypt"

Encrypted Password

syntax: java -jar <path-to-app-libs-dir>/helidon-config-encryption-{helidon-version}.jar aes masterPassword secretToEncrypt

example: java -jar libs/helidon-config-encryption-3.2.12.jar aes myMasterPasswordForEncryption qatester4

Add the username and encrypted password in the application.yaml as given below

Security configuration

Security Configuration User details

# Configuration of secured config (encryption of passwords in property files)

security.config:

# Set to true for production - if set to true, clear text passwords will cause failure

require-encryption: false

username: qatester3

# The "master" password for AES decryption. For production, set this via system property or environment variable.

#aes.insecure-passphrase: "myMasterPasswordForEncryption"

aes-current:

#password in clear text - for non-prod environments, this is enough.

password: "${CLEAR=qatester3}"

# password: "${GCM=amTUkfeF5lo4xQv8R1DmHWcO+TVyYzpc5VsHySdsO6lbeYae5Y/MwXo5EywKFdHtG3pAs0M=}"

The username and original password i.e. qatester4/qatester4 should be used while login to the application.